--INSERT FOR Personality
INSERT INTO Personality
VALUES(100,'Ivanov','Alexander','Petrovich','m','8(928)211-00-03','8(7922)4-13-81','Alex@mail.ru','D:\Photo\1.JPG','',200,304)

INSERT INTO Personality
VALUES(101,'Sidorov','Petr','Sergeevich','m','8(903)413-80-10','8(7922)4-12-80','Petr@rambler.ru','D:\Photo\2.JPG','',201,305)

INSERT INTO Personality
VALUES(102,'Shpak','Elena','Sergeevna','w','8(918)314-15-20','8(495)1-99-92','Shpak@mail.ru','D:\Photo\3.JPG','',202,303)

INSERT INTO Personality
VALUES(103,'Nyrlieva','Lyubov','Vasilievna','w','8(928)625-16-27','8(793)2-16-11','Nyrlieva@mail.ru','D:\Photo\4.JPG','',203,300)

INSERT INTO Personality
VALUES(104,'Dzhabiev','Konstantin','Alexandrovich','m','8(918)818-28-18','8(7922)5-51-16','Dzhabiev@gmail.com','D:\Photo\5.JPG','',206,307)

INSERT INTO Personality
VALUES(105,'Galieva','Tatyana','Ivanovna','w','8(928)318-18-01','8(793)5-23-17','Galieva@mail.ru','D:\Photo\6.JPG','',204,306)

INSERT INTO Personality
VALUES(106,'Kovaleva','Svetlana','Petrovna','w','8(928)356-14-15','8(7932)6-12-15','Kovaleva@mail.ru','D:\Photo\7.JPG','',205,301)

INSERT INTO Personality
VALUES(107,'Dzhangaliev','Pavel','Andreevich','m','8(918)211-40-20','8(793)2-13-11','Pavel@gmail.com','D:\Photo\8.JPG','',207,308)

INSERT INTO Personality
VALUES(108,'Sipko','Roman','Romanovich','m','8(928)415-63-03','8(495)1-31-18','Sipko@mail.ru','D:\Photo\9.JPG','',208,311)

INSERT INTO Personality
VALUES(109,'Laskov','Sergey','Vladimirovich','m','8(928)652-31-53','8(7922)5-41-25','Sergey@rambler.ru','D:\Photo\10.JPG','',209,310)

INSERT INTO Personality
VALUES(110,'Svetlakova','Irina','Viktorovna','w','8(918)325-64-95','8(7922)5-36-81','Irina@mail.ru','D:\Photo\11.JPG','',210,302)

INSERT INTO Personality
VALUES(111,'Belekov','Alexander','Romanovich','m','8(903)492-43-78','8(7937)2-45-36','Alexander@gmail.com','D:\Photo\12.JPG','',211,309)

INSERT INTO Personality
VALUES(112,'Sichev','Ilya','Konstantinovich','m','8(918)632-61-06','8(7937)4-63-16','Sichev@rambler.ru','D:\Photo\13.JPG','',212,312)

INSERT INTO Personality
VALUES(113,'Kropotkina','Julia','Valerievna','w','8(903)416-32-20','8(793)5-31-88','Julia@mail.ru','D:\Photo\14.JPG','',213,306)

INSERT INTO Personality
VALUES(114,'Kalayan','Edgar','Badrosovich','m','8(918)244-12-65','8(7922)4-54-81','Edgar@mail.ru','D:\Photo\15.JPG','',214,313)

INSERT INTO Personality
VALUES(115,'Koshkin','Anton','Vladimirovich','m','8(928)366-14-62','8(495)1-18-66','Koshkin@mail.ru','D:\Photo\16.JPG','',215,313)

INSERT INTO Personality
VALUES(116,'Ivanov','Alexey','Petrovich','m','8(928)211-00-04','8(812)3-21-80','Alexey@mail.ru','D:\Photo\17.JPG','',216,304)

INSERT INTO Personality
VALUES(117,'Siniy','Dmitriy','Alexeevich','m','8(928)456-95-46','8(793)5-74-63','Siniy@gmail.com','D:\Photo\18.JPG','',217,308)

INSERT INTO Personality
VALUES(118,'Inyanov','Artem','Petrovich','m','8(988)635-48-68','8(793)5-73-16','Inyanov@rambler.ru','D:\Photo\19.JPG','',218,307)

--INSERT FOR PlaceResidence
INSERT INTO PlaceResidence
VALUES(200,'Minvody','Pyshkina','23','')

INSERT INTO PlaceResidence
VALUES(201,'Minvody','Lomovaya','58','')

INSERT INTO PlaceResidence
VALUES(202,'Moscow','Sydakova','402/A','23')

INSERT INTO PlaceResidence
VALUES(203,'Pyatigorsk','Vlasova','34','5')

INSERT INTO PlaceResidence
VALUES(204,'Pyatigorsk','Bytirina','40','')

INSERT INTO PlaceResidence
VALUES(205,'Zeleznovodsk','Lenina','21','')

INSERT INTO PlaceResidence
VALUES(206,'Minvody','Stavropolskaya','34','21')

INSERT INTO PlaceResidence
VALUES(207,'Pyatigorsk','Anisimova','128/B','')

INSERT INTO PlaceResidence
VALUES(208,'Moscow','Sydakova','402/A','41')

INSERT INTO PlaceResidence
VALUES(209,'Minvody','Zeleznovodskaya','91','')

INSERT INTO PlaceResidence
VALUES(210,'Essentyki','Sovetskaya','90','')

INSERT INTO PlaceResidence
VALUES(211,'Kislovodsk','Veselaya','102','52')

INSERT INTO PlaceResidence
VALUES(212,'Kislovodsk','Aviachii','5','')

INSERT INTO PlaceResidence
VALUES(213,'Pyatigorsk','Anisimova','63','')

INSERT INTO PlaceResidence
VALUES(214,'Minvody','Lomovaya','105','')

INSERT INTO PlaceResidence
VALUES(215,'Moscow','Zarechie','418/B','39')

INSERT INTO PlaceResidence
VALUES(216,'S.Peterbyrg','Kazanskaya','200','')

INSERT INTO PlaceResidence
VALUES(217,'Pyatigorsk','Baksanskaya','23','6')

INSERT INTO PlaceResidence
VALUES(218,'Pyatigorsk','Baksanskaya','23','15')

--INSERT FOR Position
INSERT INTO Position
VALUES(300,'Glavniyi byxgalter',400)

INSERT INTO Position
VALUES(301,'byxgalter',400)

INSERT INTO Position
VALUES(302,'cassir',400)

INSERT INTO Position
VALUES(303,'Nachalnik otdela kadrov',401)

INSERT INTO Position
VALUES(304,'Programmist',402)

INSERT INTO Position
VALUES(305,'Inzhener-programmist',402)

INSERT INTO Position
VALUES(306,'Razrabotchik',402)

INSERT INTO Position
VALUES(307,'Naladchik',403)

INSERT INTO Position
VALUES(308,'System administrator',403)

INSERT INTO Position
VALUES(309,'Arhitektor',404)

INSERT INTO Position
VALUES(310,'Nachalnik otdela proektirovaniya',404)

INSERT INTO Position
VALUES(311,'Nachalnik otdela testirovaniya',405)

INSERT INTO Position
VALUES(312,'Inzhener-tester',405)

INSERT INTO Position
VALUES(313,'tester',405)

--INSERT FOR Subdivision
INSERT INTO Subdivision
VALUES(400,'Buxgalteriya')

INSERT INTO Subdivision
VALUES(401,'Otdel kadrov')

INSERT INTO Subdivision
VALUES(402,'Otdel razrabotki')

INSERT INTO Subdivision
VALUES(403,'Otdel naladchikov')

INSERT INTO Subdivision
VALUES(404,'Otdel proektirovaniya')

INSERT INTO Subdivision
VALUES(405,'Otdel testirovaniya')



